300 |
How can I change the font for entire item
|
299 |
How do I vertically align a cell
Procedure OnCreate Forward Send OnCreate Set ComDrawGridLines to OLEexRowLines Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "MultipleLine" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDef of hoColumn OLEexCellSingleLine to False Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "VAlign" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "This is a bit of long text that should break the line" to h Set ComCellCaption of hoItems h 1 to "top" Set ComCellVAlignment of hoItems h 1 to OLEexTop Get ComAddItem of hoItems "This is a bit of long text that should break the line" to h Set ComCellCaption of hoItems h 1 to "middle" Set ComCellVAlignment of hoItems h 1 to OLEexMiddle Get ComAddItem of hoItems "This is a bit of long text that should break the line" to h Set ComCellCaption of hoItems h 1 to "bottom" Set ComCellVAlignment of hoItems h 1 to OLEexBottom Send Destroy to hoItems End_Procedure |
298 |
How can I change the position of an item
|
297 |
How do I find an item based on a path
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Set ComItemData of hoItems (ComInsertItem(hoItems,h,"Child 2")) to 1234 Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComFindPath(hoItems,"Root 1\Child 1")) to True Send Destroy to hoItems End_Procedure |
296 |
How do I find an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComFindItem(hoItems,"Child 2",0,Nothing)) to True Send Destroy to hoItems End_Procedure |
295 |
How can I insert a hyperlink or an anchor element
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellCaptionFormat of hoItems (ComAddItem(hoItems,"Just an <a1>anchor</a> element ...")) 0 to OLEexHTML Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellCaptionFormat of hoItems1 (ComAddItem(hoItems1,"Just another <a2>anchor</a> element ...")) 0 to OLEexHTML Send Destroy to hoItems1 End_Procedure |
294 |
How do I find the index of the item based on its handle
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComItemByIndex(hoItems,(ComItemToIndex(hoItems,h)))) to True Send Destroy to hoItems End_Procedure |
293 |
How do I find the handle of the item based on its index
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComItemByIndex(hoItems,1)) to True Send Destroy to hoItems End_Procedure |
292 |
How can I find the cell being clicked in a radio group
Procedure OnCreate Forward Send OnCreate Set ComMarkSearchColumn to False Set ComSelBackColor to (RGB(255,255,128)) Set ComSelForeColor to (RGB(0,0,0)) Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Get ComAdd of hoColumns2 "C3" to Nothing Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Radio 1" Set ComCellHasRadioButton of hoItems h 1 to True Set ComCellRadioGroup of hoItems h 1 to 1234 Set ComCellCaption of hoItems h 2 to "Radio 2" Set ComCellHasRadioButton of hoItems h 2 to True Set ComCellRadioGroup of hoItems h 2 to 1234 Set ComCellState of hoItems h 1 to 1 Set ComCellBold of hoItems (ComCellChecked(hoItems,1234)) to True Send Destroy to hoItems End_Procedure |
291 |
Can I add a +/- ( expand / collapse ) buttons to each item, so I can load the child items later
Procedure OnCreate Forward Send OnCreate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemHasChildren of hoItems (ComAddItem(hoItems,"parent item with no child items")) to True Get ComAddItem of hoItems "next item" to Nothing Send Destroy to hoItems End_Procedure |
290 |
Can I let the user to resize at runtime the specified item
Procedure OnCreate Forward Send OnCreate Set ComScrollBySingleLine to True Set ComDrawGridLines to OLEexRowLines Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemAllowSizing of hoItems (ComAddItem(hoItems,"resizable item")) to True Get ComAddItem of hoItems "not resizable item" to Nothing Send Destroy to hoItems End_Procedure |
289 |
How can I change the size ( width, height ) of the picture
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Variant vPicture Get ComExecuteTemplate "loadpicture(`c:\exontrol\images\zipdisk.gif`)" to vPicture Set ComCellPicture of hoItems h 0 to (vPicture) Set ComCellPictureWidth of hoItems h 0 to 24 Set ComCellPictureHeight of hoItems h 0 to 24 Set ComItemHeight of hoItems h to 32 Get ComAddItem of hoItems "Root 2" to h Variant vPicture1 Get ComExecuteTemplate "loadpicture(`c:\exontrol\images\zipdisk.gif`)" to vPicture1 Set ComCellPicture of hoItems h 0 to (vPicture1) Set ComItemHeight of hoItems h to 48 Send Destroy to hoItems End_Procedure |
288 |
How do I unselect an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComSelectItem of hoItems h to False Send Destroy to hoItems End_Procedure |
287 |
How do I find the selected item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComSelectItem of hoItems h to True Set ComItemBold of hoItems (ComSelectedItem(hoItems,0)) to True Send Destroy to hoItems End_Procedure |
286 |
How do I select an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComSelectItem of hoItems h to True Send Destroy to hoItems End_Procedure |
285 |
Can I display a button with some picture or icon inside
Procedure OnCreate Forward Send OnCreate Set ComHTMLPicture "p1" to "c:\exontrol\images\zipdisk.gif" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to " Button <img>p1</img> " Set ComCellCaptionFormat of hoItems h 1 to OLEexHTML Set ComCellHAlignment of hoItems h 1 to OLERightAlignment Set ComCellHasButton of hoItems h 1 to True Set ComItemHeight of hoItems h to 48 Send Destroy to hoItems End_Procedure |
284 |
Can I display a button with some picture or icon inside
Procedure OnCreate Forward Send OnCreate Send ComImages "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to " Button <img>1</img> " Set ComCellCaptionFormat of hoItems h 1 to OLEexHTML Set ComCellHAlignment of hoItems h 1 to OLERightAlignment Set ComCellHasButton of hoItems h 1 to True Send Destroy to hoItems End_Procedure |
283 |
Can I display a button with some icon inside
Procedure OnCreate Forward Send OnCreate Send ComImages "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to " <img>1</img> " Set ComCellCaptionFormat of hoItems h 1 to OLEexHTML Set ComCellHAlignment of hoItems h 1 to OLERightAlignment Set ComCellHasButton of hoItems h 1 to True Send Destroy to hoItems End_Procedure |
282 |
How can I assign multiple icon/picture to a cell
Procedure OnCreate Forward Send OnCreate Set ComHTMLPicture "p1" to "c:\exontrol\images\zipdisk.gif" Set ComHTMLPicture "p2" to "c:\exontrol\images\auction.gif" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "text <img>p1</img> another picture <img>p2</img> and so on" to h Set ComCellCaptionFormat of hoItems h 0 to OLEexHTML Variant vPicture Get ComExecuteTemplate "loadpicture(`c:\exontrol\images\colorize.gif`)" to vPicture Set ComCellPicture of hoItems h 0 to (vPicture) Set ComItemHeight of hoItems h to 48 Get ComAddItem of hoItems "Root 2" to Nothing Send Destroy to hoItems End_Procedure |
281 |
How can I assign an icon/picture to a cell
|
280 |
How can I assign multiple icons/pictures to a cell
Procedure OnCreate Forward Send OnCreate Send ComImages "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root <img>1</img> 1, <img>2</img>, ... and so on " to h Set ComCellCaptionFormat of hoItems h 0 to OLEexHTML Send Destroy to hoItems End_Procedure |
279 |
How can I assign multiple icons/pictures to a cell
Procedure OnCreate Forward Send OnCreate Send ComImages "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Set ComCellImages of hoItems h 0 to "1,2,3" Send Destroy to hoItems End_Procedure |
278 |
How can I assign an icon/picture to a cell
Procedure OnCreate Forward Send OnCreate Send ComImages "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=" Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Set ComCellImage of hoItems h 0 to 1 Set ComCellImage of hoItems (ComInsertItem(hoItems,h,"Child 1")) 0 to 2 Set ComCellImage of hoItems (ComInsertItem(hoItems,h,"Child 2")) 0 to 3 Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
277 |
How can I get the handle of an item based on the handle of the cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComCellItem(hoItems,(ComItemCell(hoItems,h,0)))) to True Send Destroy to hoItems End_Procedure |
276 |
How can I display a button inside the item or cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to " Button 1 " Set ComCellHAlignment of hoItems h 1 to OLERightAlignment Set ComCellHasButton of hoItems h 1 to True Get ComAddItem of hoItems "Cell 2" to h Set ComCellCaption of hoItems h 1 to " Button 2 " Set ComCellHAlignment of hoItems h 1 to OLECenterAlignment Set ComCellHasButton of hoItems h 1 to True Send Destroy to hoItems End_Procedure |
275 |
How can I change the state of a radio button
Procedure OnCreate Forward Send OnCreate Set ComMarkSearchColumn to False Set ComSelBackColor to (RGB(255,255,128)) Set ComSelForeColor to (RGB(0,0,0)) Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Get ComAdd of hoColumns2 "C3" to Nothing Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Radio 1" Set ComCellHasRadioButton of hoItems h 1 to True Set ComCellRadioGroup of hoItems h 1 to 1234 Set ComCellCaption of hoItems h 2 to "Radio 2" Set ComCellHasRadioButton of hoItems h 2 to True Set ComCellRadioGroup of hoItems h 2 to 1234 Set ComCellState of hoItems h 1 to 1 Send Destroy to hoItems End_Procedure |
274 |
How can I assign a radio button to a cell
Procedure OnCreate Forward Send OnCreate Set ComMarkSearchColumn to False Set ComSelBackColor to (RGB(255,255,128)) Set ComSelForeColor to (RGB(0,0,0)) Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Get ComAdd of hoColumns2 "C3" to Nothing Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Radio 1" Set ComCellHasRadioButton of hoItems h 1 to True Set ComCellRadioGroup of hoItems h 1 to 1234 Set ComCellCaption of hoItems h 2 to "Radio 2" Set ComCellHasRadioButton of hoItems h 2 to True Set ComCellRadioGroup of hoItems h 2 to 1234 Set ComCellState of hoItems h 1 to 1 Send Destroy to hoItems End_Procedure |
273 |
How can I change the state of a checkbox
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Check Box" Set ComCellHasCheckBox of hoItems h 1 to True Set ComCellState of hoItems h 1 to 1 Send Destroy to hoItems End_Procedure |
272 |
How can I assign a checkbox to a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Check Box" Set ComCellHasCheckBox of hoItems h 1 to True Send Destroy to hoItems End_Procedure |
271 |
How can I display an item or a cell on multiple lines
Procedure OnCreate Forward Send OnCreate Set ComScrollBySingleLine to True Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "This is bit of text that's shown on multiple lines" Set ComCellSingleLine of hoItems h 1 to False Send Destroy to hoItems End_Procedure |
270 |
How can I assign a tooltip to a cell
|
269 |
How can I associate an extra data to a cell
|
268 |
How do I enable or disable a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Cell 2" Set ComCellEnabled of hoItems h 1 to False Send Destroy to hoItems End_Procedure |
267 |
How do I change the cell's foreground color
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Cell 2" Set ComCellForeColor of hoItems h 1 to (RGB(255,0,0)) Send Destroy to hoItems End_Procedure |
266 |
How do I change the visual effect for the cell, using your EBN files
|
265 |
How do I change the cell's background color
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Cell 2" Set ComCellBackColor of hoItems h 1 to (RGB(255,0,0)) Send Destroy to hoItems End_Procedure |
264 |
How do I change the caption or value for a particular cell
|
263 |
How do I get the handle of the cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComCellBold of hoItems (ComItemCell(hoItems,h,0)) to True Send Destroy to hoItems End_Procedure |
262 |
How do I retrieve the focused item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComFocusItem(hoItems)) to True Send Destroy to hoItems End_Procedure |
261 |
How do I get the number or count of child items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems (ComChildCount(hoItems,h)) to Nothing Send Destroy to hoItems End_Procedure |
260 |
How do I enumerate the visible items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Set ComItemBold of hoItems (ComFirstVisibleItem(hoItems)) to True Set ComItemBold of hoItems (ComNextVisibleItem(hoItems,(ComFirstVisibleItem(hoItems)))) to True Send Destroy to hoItems End_Procedure |
259 |
How do I enumerate the siblings items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Set ComItemBold of hoItems (ComNextSiblingItem(hoItems,(ComFirstVisibleItem(hoItems)))) to True Set ComItemBold of hoItems (ComPrevSiblingItem(hoItems,(ComNextSiblingItem(hoItems,(ComFirstVisibleItem(hoItems)))))) to True Send Destroy to hoItems End_Procedure |
258 |
How do I get the parent item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComItemParent(hoItems,(ComItemChild(hoItems,h)))) to True Send Destroy to hoItems End_Procedure |
257 |
How do I get the first child item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Set ComItemBold of hoItems (ComItemChild(hoItems,h)) to True Send Destroy to hoItems End_Procedure |
256 |
How do I enumerate the root items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComItemBold of hoItems (ComRootItem(hoItems,0)) to True Set ComItemUnderline of hoItems (ComRootItem(hoItems,1)) to True Send Destroy to hoItems End_Procedure |
255 |
I have a hierarchy, how can I count the number of root items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root 1" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Get ComAddItem of hoItems "Root 2" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Get ComAddItem of hoItems (ComRootCount(hoItems)) to Nothing Send Destroy to hoItems End_Procedure |
254 |
How can I make an item unselectable, or not selectable
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "unselectable - you can't get selected" to h Set ComSelectableItem of hoItems h to False Get ComAddItem of hoItems "selectable" to Nothing Send Destroy to hoItems End_Procedure |
253 |
How can I hide or show an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "hidden" to h Set ComItemHeight of hoItems h to 0 Set ComSelectableItem of hoItems h to False Get ComAddItem of hoItems "visible" to Nothing Send Destroy to hoItems End_Procedure |
252 |
How can I change the height for all items
|
251 |
How do I change the height of an item
Procedure OnCreate Forward Send OnCreate Set ComScrollBySingleLine to True Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemHeight of hoItems (ComAddItem(hoItems,"height")) to 128 Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "enabled" to Nothing Send Destroy to hoItems1 End_Procedure |
250 |
How do I disable or enable an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComEnableItem of hoItems (ComAddItem(hoItems,"disabled")) to False Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "enabled" to Nothing Send Destroy to hoItems1 End_Procedure |
249 |
How do I display as strikeout a cell
|
248 |
How do I display as strikeout a cell or an item
|
247 |
How do I display as strikeout an item
|
246 |
How do I underline a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellUnderline of hoItems (ComAddItem(hoItems,"underline")) 0 to True Send Destroy to hoItems End_Procedure |
245 |
How do I underline a cell or an item
|
244 |
How do I underline an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemUnderline of hoItems (ComAddItem(hoItems,"underline")) to True Send Destroy to hoItems End_Procedure |
243 |
How do I display as italic a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellItalic of hoItems (ComAddItem(hoItems,"italic")) 0 to True Send Destroy to hoItems End_Procedure |
242 |
How do I display as italic a cell or an item
|
241 |
How do I display as italic an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemItalic of hoItems (ComAddItem(hoItems,"italic")) to True Send Destroy to hoItems End_Procedure |
240 |
How do I bold a cell
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellBold of hoItems (ComAddItem(hoItems,"bold")) 0 to True Send Destroy to hoItems End_Procedure |
239 |
How do I bold a cell or an item
|
238 |
How do I bold an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComItemBold of hoItems (ComAddItem(hoItems,"bold")) to True Send Destroy to hoItems End_Procedure |
237 |
How do I change the foreground color for the item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant hC Get ComInsertItem of hoItems h "Child 1" to hC Set ComItemForeColor of hoItems hC to (RGB(255,0,0)) Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
236 |
How do I change the visual appearance for the item, using your EBN technology
Procedure OnCreate Forward Send OnCreate Variant voAppearance Get ComVisualAppearance to voAppearance Handle hoAppearance Get Create (RefClass(cComAppearance)) to hoAppearance Set pvComObject of hoAppearance to voAppearance Get ComAdd of hoAppearance 1 "c:\exontrol\images\normal.ebn" to Nothing Send Destroy to hoAppearance Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant hC Get ComInsertItem of hoItems h "Child 1" to hC Set ComItemBackColor of hoItems hC to |CI$1000000 Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
235 |
How do I change the background color for the item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Variant hC Get ComInsertItem of hoItems h "Child 1" to hC Set ComItemBackColor of hoItems hC to (RGB(255,0,0)) Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
234 |
How do I expand or collapse an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
233 |
How do I associate an extra data to an item
|
232 |
How do I get the number or count of items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 (ComItemCount(hoItems1)) to Nothing Send Destroy to hoItems1 End_Procedure |
231 |
How can I change at runtime the parent of the item
|
230 |
How can I sort the items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send Destroy to hoItems Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComItem of hoColumns1 "Default" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComSortOrder of hoColumn to OLESortDescending Send Destroy to hoColumn Send Destroy to hoColumns1 End_Procedure |
229 |
How do I sort the child items
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Root" to h Get ComInsertItem of hoItems h "Child 1" to Nothing Get ComInsertItem of hoItems h "Child 2" to Nothing Set ComExpandItem of hoItems h to True Send ComSortChildren of hoItems h 0 False Send Destroy to hoItems End_Procedure |
228 |
How can I remove or delete all items
|
227 |
How can I remove or delete an item
|
226 |
How can I add or insert child items
Procedure OnCreate Forward Send OnCreate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Variant h Get ComAddItem of hoItems "Cell 1" to h Set ComCellCaption of hoItems h 1 to "Cell 2" Set ComCellCaption of hoItems (ComInsertItem(hoItems,h,"Cell 3")) 1 to "Cell 4" Set ComCellCaption of hoItems (ComInsertItem(hoItems,h,"Cell 5")) 1 to "Cell 6" Set ComExpandItem of hoItems h to True Send Destroy to hoItems End_Procedure |
225 |
How can I add or insert a child item
Procedure OnCreate Forward Send OnCreate Set ComLinesAtRoot to OLEexLinesAtRoot Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Default" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComInsertItem of hoItems (ComAddItem(hoItems,"root")) "child" to Nothing Send Destroy to hoItems End_Procedure |
224 |
How can I add or insert an item
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "C1" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "C2" to Nothing Send Destroy to hoColumns1 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellCaption of hoItems (ComAddItem(hoItems,"Cell 1")) 1 to "Cell 2" Variant h Get ComAddItem of hoItems "Cell 3" to h Set ComCellCaption of hoItems h 1 to "Cell 4" Send Destroy to hoItems End_Procedure |
223 |
How can I add or insert an item
|
222 |
How can I get the columns as they are shown in the control's sortbar
|
221 |
How can I access the properties of a column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "A" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn Get ComItem of hoColumns1 "A" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComHeaderBold of hoColumn to True Send Destroy to hoColumn Send Destroy to hoColumns1 End_Procedure |
220 |
How can I remove all the columns
|
219 |
How can I remove a column
|
218 |
How can I get the number or the count of columns
|
217 |
How can I change the font for all cells in the entire column
Procedure OnCreate Forward Send OnCreate Variant f Get Comcreateobject "StdFont" to f Set ComName to "Tahoma" Set ComSize to 12 Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Variant voConditionalFormat Get ComAdd of hoConditionalFormats "1" Nothing to voConditionalFormat Handle hoConditionalFormat Get Create (RefClass(cComConditionalFormat)) to hoConditionalFormat Set pvComObject of hoConditionalFormat to voConditionalFormat Set ComFont of hoConditionalFormat to f Set ComApplyTo of hoConditionalFormat to OLEexFormatToColumns Send Destroy to hoConditionalFormat Send Destroy to hoConditionalFormats Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
216 |
How can I change the background color for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComBackColor to (RGB(255,0,0)) Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
215 |
How can I change the foreground color for all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComForeColor to (RGB(255,0,0)) Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
214 |
How can I show as strikeout all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComStrikeOut to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
213 |
How can I underline all cells in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComUnderline to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
212 |
How can I show in italic all data in the column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComItalic to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
211 |
How can I bold the entire column
Procedure OnCreate Forward Send OnCreate Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "1" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComBold to True Set ComApplyTo to OLEexFormatToColumns Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Column" to Nothing Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems 0 to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 1 to Nothing Send Destroy to hoItems1 End_Procedure |
210 |
How can I display a computed column and highlight some values that are negative or less than a value
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "A" to Nothing Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Get ComAdd of hoColumns1 "B" to Nothing Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Variant voColumn Get ComAdd of hoColumns2 "(A+B)*1.19" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComComputedField of hoColumn to "(%0 + %1) * 1.19" Send Destroy to hoColumn Send Destroy to hoColumns2 Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Set ComCellCaption of hoItems (ComAddItem(hoItems,1)) 1 to 2 Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Set ComCellCaption of hoItems1 (ComAddItem(hoItems1,10)) 1 to 20 Send Destroy to hoItems1 Variant v Variant voConditionalFormats Get ComConditionalFormats to voConditionalFormats Handle hoConditionalFormats Get Create (RefClass(cComConditionalFormats)) to hoConditionalFormats Set pvComObject of hoConditionalFormats to voConditionalFormats Get ComAdd of hoConditionalFormats "%2 > 10" Nothing to v Send Destroy to hoConditionalFormats Variant var_ConditionalFormat Move v to var_ConditionalFormat Set ComBold to True Set ComForeColor to (RGB(255,0,0)) Set ComApplyTo to |CI$2 End_Procedure |
209 |
Can I display a computed column so it displays the VAT, or SUM
|
208 |
How can I show a column that adds values in the cells
|
207 |
Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
Procedure OnCreate Forward Send OnCreate Variant v Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Filter" to v Send Destroy to hoColumns Variant var_Column Move v to var_Column Set ComFilterOnType to True Set ComDisplayFilterButton to True Set ComAutoSearch to OLEexContains Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "Canada" to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "USA" to Nothing Send Destroy to hoItems1 End_Procedure |
206 |
Is there any function to filter the control's data as I type, something like filter on type
Procedure OnCreate Forward Send OnCreate Variant v Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Get ComAdd of hoColumns "Filter" to v Send Destroy to hoColumns Variant var_Column Move v to var_Column Set ComFilterOnType to True Set ComDisplayFilterButton to True Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "Canada" to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "USA" to Nothing Send Destroy to hoItems1 End_Procedure |
205 |
How can I programmatically filter a column
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Filter" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDisplayFilterButton of hoColumn to True Set ComFilterType of hoColumn to OLEexNonBlanks Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems Nothing to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "not empty" to Nothing Send Destroy to hoItems1 Send ComApplyFilter End_Procedure |
204 |
How can I show or display the control's filter
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Filter" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDisplayFilterButton of hoColumn to True Send Destroy to hoColumn Send Destroy to hoColumns End_Procedure |
203 |
How can I customize the items being displayed in the drop down filter window
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "Custom Filter" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComDisplayFilterButton of hoColumn to True Set ComDisplayFilterPattern of hoColumn to False Set ComCustomFilter of hoColumn to "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*.txt|*.log" Set ComFilterType of hoColumn to OLEexPattern Set ComFilter of hoColumn to "*.xls" Send Destroy to hoColumn Send Destroy to hoColumns Variant voItems Get ComItems to voItems Handle hoItems Get Create (RefClass(cComItems)) to hoItems Set pvComObject of hoItems to voItems Get ComAddItem of hoItems "excel.xls" to Nothing Send Destroy to hoItems Variant voItems1 Get ComItems to voItems1 Handle hoItems1 Get Create (RefClass(cComItems)) to hoItems1 Set pvComObject of hoItems1 to voItems1 Get ComAddItem of hoItems1 "word.doc" to Nothing Send Destroy to hoItems1 Variant voItems2 Get ComItems to voItems2 Handle hoItems2 Get Create (RefClass(cComItems)) to hoItems2 Set pvComObject of hoItems2 to voItems2 Get ComAddItem of hoItems2 "pp.pps" to Nothing Send Destroy to hoItems2 Variant voItems3 Get ComItems to voItems3 Handle hoItems3 Get Create (RefClass(cComItems)) to hoItems3 Set pvComObject of hoItems3 to voItems3 Get ComAddItem of hoItems3 "text.txt" to Nothing Send Destroy to hoItems3 Send ComApplyFilter End_Procedure |
202 |
How can I change the order or the position of the columns in the sort bar
Procedure OnCreate Forward Send OnCreate Set ComSortBarVisible to True Set ComSortBarColumnWidth to 48 Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "C1" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComSortOrder of hoColumn to OLESortAscending Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "C2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComSortOrder of hoColumn1 to OLESortDescending Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Variant voColumn2 Get ComItem of hoColumns2 "C2" to voColumn2 Handle hoColumn2 Get Create (RefClass(cComColumn)) to hoColumn2 Set pvComObject of hoColumn2 to voColumn2 Set ComSortPosition of hoColumn2 to 0 Send Destroy to hoColumn2 Send Destroy to hoColumns2 End_Procedure |
201 |
How do I arrange my columns on multiple levels
Procedure OnCreate Forward Send OnCreate Variant voColumns Get ComColumns to voColumns Handle hoColumns Get Create (RefClass(cComColumns)) to hoColumns Set pvComObject of hoColumns to voColumns Variant voColumn Get ComAdd of hoColumns "S" to voColumn Handle hoColumn Get Create (RefClass(cComColumn)) to hoColumn Set pvComObject of hoColumn to voColumn Set ComWidth of hoColumn to 32 Send Destroy to hoColumn Send Destroy to hoColumns Variant voColumns1 Get ComColumns to voColumns1 Handle hoColumns1 Get Create (RefClass(cComColumns)) to hoColumns1 Set pvComObject of hoColumns1 to voColumns1 Variant voColumn1 Get ComAdd of hoColumns1 "Level 2" to voColumn1 Handle hoColumn1 Get Create (RefClass(cComColumn)) to hoColumn1 Set pvComObject of hoColumn1 to voColumn1 Set ComLevelKey of hoColumn1 to 1 Send Destroy to hoColumn1 Send Destroy to hoColumns1 Variant voColumns2 Get ComColumns to voColumns2 Handle hoColumns2 Get Create (RefClass(cComColumns)) to hoColumns2 Set pvComObject of hoColumns2 to voColumns2 Variant voColumn2 Get ComAdd of hoColumns2 "Level 3" to voColumn2 Handle hoColumn2 Get Create (RefClass(cComColumn)) to hoColumn2 Set pvComObject of hoColumn2 to voColumn2 Set ComLevelKey of hoColumn2 to 1 Send Destroy to hoColumn2 Send Destroy to hoColumns2 Variant voColumns3 Get ComColumns to voColumns3 Handle hoColumns3 Get Create (RefClass(cComColumns)) to hoColumns3 Set pvComObject of hoColumns3 to voColumns3 Variant voColumn3 Get ComAdd of hoColumns3 "Level 4" to voColumn3 Handle hoColumn3 Get Create (RefClass(cComColumn)) to hoColumn3 Set pvComObject of hoColumn3 to voColumn3 Set ComLevelKey of hoColumn3 to 1 Send Destroy to hoColumn3 Send Destroy to hoColumns3 Variant voColumns4 Get ComColumns to voColumns4 Handle hoColumns4 Get Create (RefClass(cComColumns)) to hoColumns4 Set pvComObject of hoColumns4 to voColumns4 Variant voColumn4 Get ComAdd of hoColumns4 "Level 1" to voColumn4 Handle hoColumn4 Get Create (RefClass(cComColumn)) to hoColumn4 Set pvComObject of hoColumn4 to voColumn4 Set ComLevelKey of hoColumn4 to "2" Send Destroy to hoColumn4 Send Destroy to hoColumns4 Variant voColumns5 Get ComColumns to voColumns5 Handle hoColumns5 Get Create (RefClass(cComColumns)) to hoColumns5 Set pvComObject of hoColumns5 to voColumns5 Variant voColumn5 Get ComAdd of hoColumns5 "Level 2" to voColumn5 Handle hoColumn5 Get Create (RefClass(cComColumn)) to hoColumn5 Set pvComObject of hoColumn5 to voColumn5 Set ComLevelKey of hoColumn5 to "2" Send Destroy to hoColumn5 Send Destroy to hoColumns5 Variant voColumns6 Get ComColumns to voColumns6 Handle hoColumns6 Get Create (RefClass(cComColumns)) to hoColumns6 Set pvComObject of hoColumns6 to voColumns6 Variant voColumn6 Get ComAdd of hoColumns6 "Level 3" to voColumn6 Handle hoColumn6 Get Create (RefClass(cComColumn)) to hoColumn6 Set pvComObject of hoColumn6 to voColumn6 Set ComLevelKey of hoColumn6 to "2" Send Destroy to hoColumn6 Send Destroy to hoColumns6 Variant voColumns7 Get ComColumns to voColumns7 Handle hoColumns7 Get Create (RefClass(cComColumns)) to hoColumns7 Set pvComObject of hoColumns7 to voColumns7 Variant voColumn7 Get ComAdd of hoColumns7 "Level 4" to voColumn7 Handle hoColumn7 Get Create (RefClass(cComColumn)) to hoColumn7 Set pvComObject of hoColumn7 to voColumn7 Set ComLevelKey of hoColumn7 to "2" Send Destroy to hoColumn7 Send Destroy to hoColumns7 Variant voColumns8 Get ComColumns to voColumns8 Handle hoColumns8 Get Create (RefClass(cComColumns)) to hoColumns8 Set pvComObject of hoColumns8 to voColumns8 Variant voColumn8 Get ComAdd of hoColumns8 "E" to voColumn8 Handle hoColumn8 Get Create (RefClass(cComColumn)) to hoColumn8 Set pvComObject of hoColumn8 to voColumn8 Set ComWidth of hoColumn8 to 32 Send Destroy to hoColumn8 Send Destroy to hoColumns8 End_Procedure |